﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="rkp_officer_unit_excel.aspx.cs" Inherits="Shuba.Web.master.rkp_officer_unit_excel" %>
<table border=0>
	<tr>
		<td colspan="14"><b>REKAP PROSPECT PER OFFICER PER UNIT</b></td>
    </tr>
	<tr>
		<td colspan="14">&nbsp;</td>
    </tr>
	<tr>
		<td><b>UNIT CODE</b></td>
		<td colspan="13"><b>: <%=Request["unit_code"]%></b></td>
    </tr>
    <tr>
		<td><b>PERIOD</b></td>
		<td colspan="13"><b>: <%=Request["start"] + " - " + Request["end"]%></b></td>
	</tr>
	<tr>
		<td colspan="14">&nbsp;</td>
    </tr>
</table>
		<asp:Repeater ID="rep1" runat="server">
			<HeaderTemplate>
				<table border=1>
					<tr>
						<td bgcolor="#b4b4b4"><b>SALES OFFICER</b></td>
						<td bgcolor="#b4b4b4"><b>OFFICER NAME</b></td>
						<td bgcolor="#b4b4b4"><b>PROSPECT REF. NO</b></td>
						<td bgcolor="#b4b4b4"><b>PROSPECT NAME</b></td>
						<td bgcolor="#b4b4b4"><b>DATE ENTERED</b></td>
						<td bgcolor="#b4b4b4"><b>GOOD UNTIL WHEN</b></td>
						<td bgcolor="#b4b4b4"><b>PRODUCT TYPE</b></td>
						<td bgcolor="#b4b4b4"><b>TYPE OF DEBTOR</b></td>
						<td bgcolor="#b4b4b4"><b>CUST. STATUS</b></td>
						<td bgcolor="#b4b4b4"><b>ACTIVITY</b></td>
						<td bgcolor="#b4b4b4"><b>STATUS PROSPECTING</b></td>
						<td bgcolor="#b4b4b4"><b>DATE CLOSE DEAL</b></td>
						<td bgcolor="#b4b4b4"><b>NO OF VISIT</b></td>
						<td bgcolor="#b4b4b4"><b>ACCOUNT NO</b></td>
						<td bgcolor="#b4b4b4"><b>DISBURSED DATE</b></td>
						<td bgcolor="#b4b4b4"><b>APP. REJECTED DATE</b></td>
					</tr>
			</HeaderTemplate>
			<ItemTemplate>
					<tr>
						<td><%# Eval("AO_CODE")%></td>
						<td><%# Eval("OFFICER_NAME")%></td>
						<td><%# Eval("PROSPECT_NO")%></td>
						<td><%# Eval("FULL_NAME")%></td>
						<td><%# Eval("ENTRY_DATE", "{0:dd MMM yyyy}")%></td>
						<td><%# Eval("GU_FUP", "{0:dd MMM yyyy}")%></td>
						<td><%# Eval("PRODUCT_TYPE")%></td>
						<td><%# Eval("DEBTOR_TYPE")%></td>
						<td><%# Eval("PROSPECT_TYPE")%></td>
						<td><%# Eval("CYCLE_STATUS")%></td>
						<td><%# Eval("PROGRESS_STATUS")%></td>
						<td><%# Eval("CLOSE_DEAL_DATE", "{0:dd MMM yyyy}")%></td>
						<td><%# Eval("NO_OF_VISIT", "{0:N0}")%></td>
						<td><%# Eval("ACC_NO")%></td>
						<td><%# Eval("DISBURSE_DATE", "{0:dd MMM yyyy}")%></td>
						<td><%# Eval("REJECTED_DATE", "{0:dd MMM yyyy}")%></td>
					</tr>
			</ItemTemplate>
			<FooterTemplate>
				</table>
			</FooterTemplate>
		</asp:Repeater>
